﻿CREATE TABLE [dbo].[ContainerPrelading] (
    [Id]              INT           IDENTITY (1, 1) NOT NULL,
    [IsDeleted]       BIT           NOT NULL,
    [CreatedDate]     DATETIME      NOT NULL,
    [ModifiedDate]    DATETIME      NOT NULL,
    [TaskId]          INT           NOT NULL,
    [ContainerNumber] VARCHAR (32)  NOT NULL,
    [BillNumber]      VARCHAR (32)  NULL,
    [Conveyance]      VARCHAR (32)  NULL,
    [VoyageNumber]    VARCHAR (16)  NULL,
    [Weight]          INT           NULL,
    [PackageAmount]   INT           NULL,
    [PreladingDate]   DATETIME      NULL,
    [PreladingStatus] NVARCHAR (32) NULL,
    [WarningMessage]  NVARCHAR (64) NULL
);

